<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="utf-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> 
<%@ taglib prefix="spring" uri="http://www.springframework.org/tags" %>
<%@ taglib prefix="form" uri="http://www.springframework.org/tags/form" %>
<c:set var="contextPath" value="${pageContext.request.contextPath}" ></c:set>
<!DOCTYPE html >
<html lang="en">
	<head>
		<link rel="stylesheet" href="${pageContext.request.contextPath}/static/assets/css/bootstrap.min.css" />
		<link rel="stylesheet" href="${pageContext.request.contextPath}/static/assets/css/font-awesome.min.css" />
		<link rel="stylesheet" href="${pageContext.request.contextPath}/static/assets/css/ace-fonts.css" />
		<link rel="stylesheet" href="${pageContext.request.contextPath}/static/assets/css/ace.min.css" id="main-ace-style" />
		<link rel="stylesheet" href="${pageContext.request.contextPath}/static/assets/css/ace-skins.min.css" />
		<link rel="stylesheet" href="${pageContext.request.contextPath}/static/assets/css/ace-rtl.min.css" />
		<script src="${pageContext.request.contextPath}/static/assets/js/ace-extra.min.js"></script>
	</head>

	<body class="no-skin">
			<!-- /section:basics/sidebar -->
			<div class="main-content">
				<!-- #section:basics/content.breadcrumbs -->
				<div class="breadcrumbs" id="breadcrumbs">
					<script type="text/javascript">
						try{ace.settings.check('breadcrumbs' , 'fixed')}catch(e){}
					</script>

					<ul class="breadcrumb">
						<li>
							<i class="ace-icon fa fa-home home-icon"></i>
							<a href="#">Home</a>
						</li>

						<li>
							<a href="#">Tables</a>
						</li>
						<li class="active">Simple &amp; Dynamic</li>
					</ul><!-- /.breadcrumb -->

					<!-- #section:basics/content.searchbox -->
					<div class="nav-search" id="nav-search">
						<form class="form-search">
							<span class="input-icon">
								<input type="text" placeholder="Search ..." class="nav-search-input" id="nav-search-input" autocomplete="off" />
								<i class="ace-icon fa fa-search nav-search-icon"></i>
							</span>
						</form>
					</div><!-- /.nav-search -->

					<!-- /section:basics/content.searchbox -->
				</div>

				<!-- /section:basics/content.breadcrumbs -->
				<div class="page-content">
					<!-- #section:settings.box -->
					<div class="ace-settings-container" id="ace-settings-container">
						<div class="btn btn-app btn-xs btn-warning ace-settings-btn" id="ace-settings-btn">
							<i class="ace-icon fa fa-cog bigger-150"></i>
						</div>

						<div class="ace-settings-box clearfix" id="ace-settings-box">
							<div class="pull-left width-50">
								<!-- #section:settings.skins -->
								<div class="ace-settings-item">
									<div class="pull-left">
										<select id="skin-colorpicker" class="hide">
											<option data-skin="no-skin" value="#438EB9">#438EB9</option>
											<option data-skin="skin-1" value="#222A2D">#222A2D</option>
											<option data-skin="skin-2" value="#C6487E">#C6487E</option>
											<option data-skin="skin-3" value="#D0D0D0">#D0D0D0</option>
										</select>
									</div>
									<span>&nbsp; Choose Skin</span>
								</div>

								<!-- /section:settings.skins -->

								<!-- #section:settings.navbar -->
								<div class="ace-settings-item">
									<input type="checkbox" class="ace ace-checkbox-2" id="ace-settings-navbar" />
									<label class="lbl" for="ace-settings-navbar"> Fixed Navbar</label>
								</div>

								<!-- /section:settings.navbar -->

								<!-- #section:settings.sidebar -->
								<div class="ace-settings-item">
									<input type="checkbox" class="ace ace-checkbox-2" id="ace-settings-sidebar" />
									<label class="lbl" for="ace-settings-sidebar"> Fixed Sidebar</label>
								</div>

								<!-- /section:settings.sidebar -->

								<!-- #section:settings.breadcrumbs -->
								<div class="ace-settings-item">
									<input type="checkbox" class="ace ace-checkbox-2" id="ace-settings-breadcrumbs" />
									<label class="lbl" for="ace-settings-breadcrumbs"> Fixed Breadcrumbs</label>
								</div>

								<!-- /section:settings.breadcrumbs -->

								<!-- #section:settings.rtl -->
								<div class="ace-settings-item">
									<input type="checkbox" class="ace ace-checkbox-2" id="ace-settings-rtl" />
									<label class="lbl" for="ace-settings-rtl"> Right To Left (rtl)</label>
								</div>

								<!-- /section:settings.rtl -->

								<!-- #section:settings.container -->
								<div class="ace-settings-item">
									<input type="checkbox" class="ace ace-checkbox-2" id="ace-settings-add-container" />
									<label class="lbl" for="ace-settings-add-container">
										Inside
										<b>.container</b>
									</label>
								</div>

								<!-- /section:settings.container -->
							</div><!-- /.pull-left -->

							<div class="pull-left width-50">
								<!-- #section:basics/sidebar.options -->
								<div class="ace-settings-item">
									<input type="checkbox" class="ace ace-checkbox-2" id="ace-settings-hover" />
									<label class="lbl" for="ace-settings-hover"> Submenu on Hover</label>
								</div>

								<div class="ace-settings-item">
									<input type="checkbox" class="ace ace-checkbox-2" id="ace-settings-compact" />
									<label class="lbl" for="ace-settings-compact"> Compact Sidebar</label>
								</div>

								<div class="ace-settings-item">
									<input type="checkbox" class="ace ace-checkbox-2" id="ace-settings-highlight" />
									<label class="lbl" for="ace-settings-highlight"> Alt. Active Item</label>
								</div>

								<!-- /section:basics/sidebar.options -->
							</div><!-- /.pull-left -->
						</div><!-- /.ace-settings-box -->
					</div><!-- /.ace-settings-container -->

					<div class="page-header">
						<label>查询条件:</label>
						<select name="condition">
							<option value="sub">科目</option>
							<option value="id">学号</option>
							<option value="name">姓名</option>
							<option value="date">考试日期</option>
						</select>
						<span class="input-group">
							<span id="query">
							<input name="query" type="text" id="inquiry" />
							</span>
							<a class="btn btn-primary">
							
							<span id="check" >
								<i class="ui-icon ace-icon fa fa-search orange"></i>
								<span class="bigger-110">查询</span>
																<c:if test="${not empty message}">
															<script type="text/javascript">
																alert('${message}')			
															</script>
																	
															</c:if>
							</span>
							</a>
							<a href="${pageContext.request.contextPath}/teacher/showAllScore" class="btn btn-primary"> 
									
															<i class="ace-icon fa fa-key"></i>
															<span class="bigger-110">查询全部</span>
																<c:if test="${not empty message}">
															<script type="text/javascript">
																alert('${message}')			
															</script>
																	
															</c:if>
															</a>
						</span>
						
								
						
						
				</div><!-- /.page-header -->

						<div class="row">
							<div class="col-xs-12">
								<!-- PAGE CONTENT BEGINS -->
									<table id="testListTable" class="table table-striped table-bordered table-hover">
										<thead>
											<tr>
											    <th width=150>学号</th>
											    <th width=150>姓名</th>
											    <th width=150>科目</th>
											    <th width=150>考试日期</th>
											    <th width=150>成绩</th>
											   
						                    </tr>
										</thead>
						
										<tbody>
						                <c:forEach items="${scoreList }" var="score">
						                    <tr>
						                        <td>${score.userId }</td>
						                        <td>${score.userName }</td>
						                        <td>${score.subjectName }</td>
						                        <td>${score.examTimeString }</td>
						                        <td>${score.score }</td>
												
											</tr>
										</c:forEach>
										</tbody>
									</table>
									<div class="hr hr-18 dotted hr-double"></div>
								</div><!-- /.col -->
								</div><!-- /.row -->
								
<script type="text/javascript">
			window.jQuery || document.write("<script src='${pageContext.request.contextPath}/static/assets/js/jquery.min.js'>"+"<"+"/script>");
		</script>

		<script type="text/javascript">
			if('ontouchstart' in document.documentElement) document.write("<script src='${pageContext.request.contextPath}/static/assets/js/jquery.mobile.custom.min.js'>"+"<"+"/script>");
		</script>

		<script src="${pageContext.request.contextPath}/static/assets/js/bootstrap.min.js"></script>
		<script src="${pageContext.request.contextPath}/static/lib/bootstrap-switch.js"></script>
		<!-- page specific plugin scripts -->
		<script src="${pageContext.request.contextPath}/static/assets/js/jquery.dataTables.min.js"></script>
		<script src="${pageContext.request.contextPath}/static/assets/js/jquery.dataTables.bootstrap.js"></script>

		<!-- ace scripts -->
		<script src="${pageContext.request.contextPath}/static/assets/js/ace-elements.min.js"></script>
		<script src="${pageContext.request.contextPath}/static/assets/js/ace.min.js"></script>
		<script src="${pageContext.request.contextPath}/static/lib/jquery.jqprint-0.3.js"></script>
		<script src="${pageContext.request.contextPath}/static/lib/jquery-migrate-1.1.0.js"></script>

		<script src="${pageContext.request.contextPath}/static/lib/foundation-datepicker.js" type="text/javascript"></script>
								
<script type="text/javascript">		
/* 	function checkSelectedUser(selectedUser,userId){
				var targetCheck = null; //alert(targetCheck.outerHTML);
				targetCheck.checked=true;		
	} */

$(document).ready(function(){  
	$('select[name="condition"]').change(function(){
		if($(this).children('option:selected').val() == 'date'){
			$('#query').html('<input name="D1" type="text" id="D1" />~<input name="D2" type="text" id="D2" />');
		}else{
			$('#query').html('<input name="query" type="text" id="inquiry" />');
		}
	});
	$(document).on('mousedown', '#D1, #D2',  function(){
		$( this ).fdatepicker({
			format: 'yyyy-mm-dd'
		});
	});
	
	$('#check').click(function(){
		var condition = $('select[name="condition"]').val();
		var query = '';
		if(condition != 'date'){
			query = $('#inquiry').val();
		}else{
			var D1 = $('#D1').val();
			var D2 = $('#D2').val();
			if(D1 != '' && D2 != ''){
				query = D1 + ',' + D2;
			}
		}
		
		if(query != ''){
			$.ajax({
				type: 'POST',
				url: '${pageContext.request.contextPath}/teacher/getScore',
				data: {
					condition: condition,
					query: query
				},
				dataType: "json",
				success: function(data){
					if(data.success){
						var htmlString = '';
						$.each(data.resultList, function(index, item){
							htmlString += '<tr>';
							htmlString += '<td>' + item.userId + '</td>';
							htmlString += '<td>' + item.userName + '</td>';
							htmlString += '<td>' + item.subjectName + '</td>';
							htmlString += '<td>' + item.examTimeString + '</td>';
							htmlString += '<td>' + item.score + '</td>';
						
							htmlString += '</tr>';
						});
						$('tbody').html(htmlString);
					}else{
						alert("没有找到");
					}
				}
			});
		}else{
			alert("请输入查询条件");
		}
	})
	
	$(document).on('click', '.edit-subject',  function(){
	});
})  
</script>

		

	
	</script>
	<link rel="stylesheet" href="${pageContext.request.contextPath}/static/assets/css/ace.onpage-help.css" />
		<link rel="stylesheet" href="${pageContext.request.contextPath}/static/docs/assets/js/themes/sunburst.css" />

		<script type="text/javascript"> ace.vars['base'] = '..'; </script>
		<script src="${pageContext.request.contextPath}/static/assets/js/ace/elements.onpage-help.js"></script>
		<script src="${pageContext.request.contextPath}/static/assets/js/ace/ace.onpage-help.js"></script>
		<script src="${pageContext.request.contextPath}/static/docs/assets/js/rainbow.js"></script>
		<script src="${pageContext.request.contextPath}/static/docs/assets/js/language/generic.js"></script>
		<script src="${pageContext.request.contextPath}/static/docs/assets/js/language/html.js"></script>
		<script src="${pageContext.request.contextPath}/static/docs/assets/js/language/css.js"></script>
		<script src="${pageContext.request.contextPath}/static/docs/assets/js/language/javascript.js"></script>
	
	</body>
</html>
